sqoop import \
--connect jdbc:mysql://node101:3306/gmall \
--username root \
--password 123456 \
--as-textfile \
--query 'SELECT id, name, region_id, area_code, iso_code, iso_3166_2 FROM gmall.base_province WHERE $CONDITIONS AND 1 = 1' \
--delete-target-dir \
--target-dir 'hdfs://node101:8020/warehouse/app_basic/base_province/2025-04-09' \
--fields-terminated-by '\001' \
--num-mappers 1 \
--null-non-string '\\N' \
--null-string '\\N'

sqoop import \
--connect jdbc:mysql://node101:3306/gmall \
--username root \
--password 123456 \
--as-textfile \
--query 'SELECT id, region_name FROM gmall.base_region WHERE $CONDITIONS AND 1 = 1' \
--delete-target-dir \
--target-dir 'hdfs://node101:8020/warehouse/app_basic/base_region/2025-04-09' \
--fields-terminated-by '\001' \
--num-mappers 1 \
--null-non-string '\\N' \
--null-string '\\N'
